/*
 * CourseDescriptionDb.h
 *
 *  Created on: 3 May 2010
 *      Author: User
 */

#ifndef COURSEDESCRIPTIONDB_H_
#define COURSEDESCRIPTIONDB_H_
#include <string>
#include <vector>

#include "OdbcConnectionSingleton.h"

using namespace std;

class CourseDescriptionDb {
public:
	CourseDescriptionDb(const string *dbName, const string *user, const string *passwd);

	virtual ~CourseDescriptionDb();
	//return all courses
	vector<string *> getCourses() const;
	//return all courses student watch from all school years
	//vector<string *> getStudentCourses(const string *aem) const;
	//return all courses student watch from a school year
	//vector<string *> getStudentCourses(const string *aem, const string *schoolYear) const;
	string *getCourseTitle(const string *code)  const;
	string *getCourseCode(const string *title) const;
	bool saveTitle(const string *code, const string *title) const;



};

#endif /* COURSEDescriptionDB_H_ */
